﻿CREATE PROCEDURE [dbo].[proc_Supplier_Update]
	(
		@Sort int,
		@Title nvarchar(50),
		@WebAddress nvarchar(50),
		@ContactPerson nvarchar(50),
		@ContactPhone nvarchar(50),
		@Projects nvarchar(200),
		@Id int
	)
AS
	Update Supplier Set
	Sort=@Sort,
	Title=@Title,
	WebAddress=@WebAddress,
	ContactPerson=@ContactPerson,
	ContactPhone=@ContactPhone,
	Projects=@Projects
	Where Id=@Id
	RETURN
